﻿SELECT
sch.name AS [Schema],
xsc.name AS [Name],
XML_SCHEMA_NAMESPACE(sch.Name, xsc.name) AS [Text],
xsc.xml_collection_id AS [ID]
FROM
sys.xml_schema_collections AS xsc
INNER JOIN sys.schemas AS sch ON xsc.schema_id = sch.schema_id
WHERE
(
				xsc.schema_id   <> 4)
ORDER BY
[Schema] ASC,[Name] ASC;